/**
 * 
 */
package fr.sportsurbains.tools;

/**
 * @author jshi
 *
 */
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
  
public class DBHelper extends SQLiteOpenHelper {  
  
    private static final String DATABASE_NAME = "sportsurbains.db";  
    private static final int DATABASE_VERSION = 1;  
      
    public DBHelper(Context context) {  
        //CursorFactory设置为null,使用默认值  
        super(context, DATABASE_NAME, null, DATABASE_VERSION);  
    }  
  
    //数据库第一次被创建时onCreate会被调用  
    @Override  
    public void onCreate(SQLiteDatabase db) {  
        db.execSQL("CREATE TABLE IF NOT EXISTS news" +  
                "(_id VARCHAR(100) PRIMARY KEY, title TEXT, summary TEXT,image TEXT, date TEXT, link TEXT)");
        db.execSQL("CREATE TABLE IF NOT EXISTS revue_de_presse" +  
                "(_id VARCHAR(100) PRIMARY KEY, title TEXT, summary TEXT,image TEXT, date TEXT, link TEXT)");
        db.execSQL("CREATE TABLE IF NOT EXISTS videos" +  
                "(_id VARCHAR(100) PRIMARY KEY, title TEXT, summary TEXT,image TEXT, date TEXT, link TEXT)");
        db.execSQL("CREATE TABLE IF NOT EXISTS images" +  
                "(_id INTEGER PRIMARY KEY AUTOINCREMENT, link TEXT, bitmap BLOB)");
    }  
  
    //如果DATABASE_VERSION值被改为2,系统发现现有数据库版本不同,即会调用onUpgrade  
    @Override  
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {  
    }  
}  
